<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">

	<!-- 
	        督办审核信息表
	   create by wanghl@cqhrsoft.com
	-->
<hibernate-mapping>
    <class name="cn.firstsoft.modules.inspect.domain.InspectAuditInfo" table="inspect_audit_info" >
        <id name="id" type="integer">
            <column name="id" /> 
            <generator class="native" >
				<param name="sequence">INSPECT_AUDIT_INFO_ID_SEQ</param>
            </generator>
        </id>
        <property name="status" type="string">
            <column name="status" length="50" not-null="true"/>
        </property>
        <property name="createTime" type="timestamp">
            <column name="create_time"  not-null="true"/>
        </property>
        <property name="descn" type="string">
            <column name="descn" length="1000"/>
        </property>
        <many-to-one name="inspectUser" class="cn.firstsoft.modules.inspect.domain.InspectUser" fetch="select">
            <column name="inspect_user_id"/>
        </many-to-one>
        <many-to-one name="workflowSignature" class="cn.firstsoft.modules.workflow.domain.WorkflowSignature" fetch="select">
            <column name="workflow_sign_id" />
        </many-to-one>
        <many-to-one name="inspectFile" class="cn.firstsoft.modules.inspect.domain.InspectFile" fetch="select">
            <column name="inspect_file_id" />
        </many-to-one>
    
    </class>
</hibernate-mapping>
